# coding: utf-8

from . import db


class Student(db.Model):
    __tablename__ = 'user'

    autoID = db.Column(db.Integer, primary_key=True)
    userID = db.Column(db.String(20, 'utf8mb4_general_ci'), info='学号，业务主键')
    name = db.Column(db.String(20, 'utf8mb4_general_ci'), info='学生姓名')
    age = db.Column(db.Integer, info='年龄')
    sex = db.Column(db.String(10, 'utf8mb4_general_ci'), info='性别')
    isDelete = db.Column(db.Integer, server_default=db.FetchedValue(), info='是否删除')
    addTime = db.Column(db.DateTime, server_default=db.FetchedValue(), info='记录添加时间')
